# coding: utf-8
from common.models.user import User
from application import db


class BpmData(db.Model):
    __tablename__ = 'bpm_data'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    oa = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    company = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    department = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    timenum = db.Column(db.Float)
    totalnum = db.Column(db.Integer)
    date = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))




